{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Xpath解析HTML"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>edu</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>时间</th>\n",
       "      <th>职称</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>链结</th>\n",
       "      <th>公司URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>20-35k·14薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>法务经理</td>\n",
       "      <td>北京</td>\n",
       "      <td>唯医骨科</td>\n",
       "      <td>https://www.liepin.com/job/1927600483.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8880538/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>30-40k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>商业集团-投资关系专业总监</td>\n",
       "      <td>上海</td>\n",
       "      <td>弘阳集团</td>\n",
       "      <td>https://www.liepin.com/job/1927599825.shtml</td>\n",
       "      <td>https://www.liepin.com/company/729252/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>18-25k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>资产监管（股权管理）-高级经理</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国科学院控股有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927599791.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8639500/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>资产监管（成果转化）-高级经理</td>\n",
       "      <td>北京</td>\n",
       "      <td>中国科学院控股有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927599755.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8639500/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>15-18k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>电商运营经理</td>\n",
       "      <td>广州</td>\n",
       "      <td>广东骏丰频谱股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927599357.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7939826/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>电商推广专家</td>\n",
       "      <td>北京</td>\n",
       "      <td>国美控股</td>\n",
       "      <td>https://www.liepin.com/job/1927599315.shtml</td>\n",
       "      <td>https://www.liepin.com/company/3934494/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>财务人事经理</td>\n",
       "      <td>南京</td>\n",
       "      <td>南京启真基因工程有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927599305.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9640452/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>6-10k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>php开发</td>\n",
       "      <td>长沙-雨花区</td>\n",
       "      <td>湖南象盒网络科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927599165.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9949751/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>前端开发（vue）</td>\n",
       "      <td>长沙-雨花区</td>\n",
       "      <td>湖南象盒网络科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927599149.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9949751/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>13-16k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>Java高级开发工程师</td>\n",
       "      <td>长沙-雨花区</td>\n",
       "      <td>湖南象盒网络科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927599125.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9949751/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>债券销售</td>\n",
       "      <td>上海-塘桥</td>\n",
       "      <td>浙商证券</td>\n",
       "      <td>https://www.liepin.com/job/1927598555.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7873563/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>股权发行销售</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>浙商证券</td>\n",
       "      <td>https://www.liepin.com/job/1927598479.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7873563/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>3-5k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>客服专员</td>\n",
       "      <td>温州-鹿城区</td>\n",
       "      <td>南京金融资产交易中心有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927598287.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8978495/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>10-20k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>产业园招商经理</td>\n",
       "      <td>沈阳</td>\n",
       "      <td>沈阳万科企业有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927598037.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9912521/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>12-16k·14薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>火锅食材供应链专家</td>\n",
       "      <td>北京</td>\n",
       "      <td>国美控股</td>\n",
       "      <td>https://www.liepin.com/job/1927597545.shtml</td>\n",
       "      <td>https://www.liepin.com/company/3934494/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>软件工程师</td>\n",
       "      <td></td>\n",
       "      <td>泰邦生物集团</td>\n",
       "      <td>https://www.liepin.com/job/1927596409.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9803471/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>电商销售主管（经销商管理）(005303)</td>\n",
       "      <td>广州</td>\n",
       "      <td>奥飞</td>\n",
       "      <td>https://www.liepin.com/job/1927596243.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7875551/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>4-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>电商设计师</td>\n",
       "      <td>上海-长宁区</td>\n",
       "      <td>上海上室网络科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927596135.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9329710/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>3-6k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>财务助理</td>\n",
       "      <td>上海-华漕</td>\n",
       "      <td>上海上室网络科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927595949.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9329710/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>25-50k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>XOVE品牌中国区运营总监</td>\n",
       "      <td>广州-珠江新城</td>\n",
       "      <td>卓珈美容(香港)有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927594873.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12180385/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>副总建筑师</td>\n",
       "      <td>武汉</td>\n",
       "      <td>湖北中天世纪工程技术有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927594729.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8122884/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>中山区域呼叫中心主管/经理</td>\n",
       "      <td>中山</td>\n",
       "      <td>雅居乐</td>\n",
       "      <td>https://www.liepin.com/job/1927594399.shtml</td>\n",
       "      <td>https://www.liepin.com/company/185424/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>投资经理（无锡）</td>\n",
       "      <td>无锡-蠡湖</td>\n",
       "      <td>郑州康桥房地产开发有限责任公司</td>\n",
       "      <td>https://www.liepin.com/job/1927594233.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8917793/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>6-11k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>销售顾问</td>\n",
       "      <td>武汉-永清</td>\n",
       "      <td>万仕道(北京)管理咨询有限公司华南大区</td>\n",
       "      <td>https://www.liepin.com/job/1927594175.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8388695/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>20-40k·15薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>解决方案高级工程师</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>丰图科技(深圳)有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927593927.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12169397/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>售后服务专员</td>\n",
       "      <td>杭州</td>\n",
       "      <td>快捷通</td>\n",
       "      <td>https://www.liepin.com/job/1927593739.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8002546/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>商务经理（酒店方向）</td>\n",
       "      <td></td>\n",
       "      <td>北京汉方智汇科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927593657.shtml</td>\n",
       "      <td>https://www.liepin.com/company/10147775/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>市场经理</td>\n",
       "      <td>武汉-江汉区</td>\n",
       "      <td>武汉中城悦城房地产开发有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927593615.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9733701/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>工程造价专员1名（昭旺家居产投公司）</td>\n",
       "      <td>广元</td>\n",
       "      <td>同圣产业投资</td>\n",
       "      <td>https://www.liepin.com/job/1927593575.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12161893/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>20-35k·14薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>Consulting Manager/ Senior Manager</td>\n",
       "      <td></td>\n",
       "      <td>益普索(中国)咨询有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927593525.shtml</td>\n",
       "      <td>https://www.liepin.com/company/474099/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>工程管理专员1名（昭旺家居产投公司）</td>\n",
       "      <td>广元</td>\n",
       "      <td>同圣产业投资</td>\n",
       "      <td>https://www.liepin.com/job/1927593475.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12161893/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>7-10k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>招商主管</td>\n",
       "      <td>宁波</td>\n",
       "      <td>浙江驿淘科技产业服务有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927593415.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9630336/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>云平台研发工程师</td>\n",
       "      <td>南京</td>\n",
       "      <td>大全电气研究院</td>\n",
       "      <td>https://www.liepin.com/job/1927593255.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8975185/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>产业发展助理1名（昭旺家居产投公司）</td>\n",
       "      <td>广元</td>\n",
       "      <td>同圣产业投资</td>\n",
       "      <td>https://www.liepin.com/job/1927593191.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12161893/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>中专/中技及以上</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>4-5k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>驾驶员</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆川百达集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927593073.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9617291/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>5-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>投资专员1名（昭旺家居产投公司）</td>\n",
       "      <td>广元</td>\n",
       "      <td>同圣产业投资</td>\n",
       "      <td>https://www.liepin.com/job/1927593031.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12161893/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>17-25k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>软件测试工程师</td>\n",
       "      <td>北京</td>\n",
       "      <td>汽车之家</td>\n",
       "      <td>https://www.liepin.com/job/1927592871.shtml</td>\n",
       "      <td>https://www.liepin.com/company/886182/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>审计专员1名（昭旺家居产投公司）</td>\n",
       "      <td>广元</td>\n",
       "      <td>同圣产业投资</td>\n",
       "      <td>https://www.liepin.com/job/1927592869.shtml</td>\n",
       "      <td>https://www.liepin.com/company/12161893/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>店长（成都智能生活馆）</td>\n",
       "      <td>成都-牛市口</td>\n",
       "      <td>华为</td>\n",
       "      <td>https://www.liepin.com/job/1927592835.shtml</td>\n",
       "      <td>https://www.liepin.com/company/954482/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>8-12k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>财经编辑</td>\n",
       "      <td></td>\n",
       "      <td>北京双志伟业网络科技有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927592317.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8611423/</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         edu     经验          薪水           时间  \\\n",
       "0       统招本科   3年以上  20-35k·14薪  2020年04月20日   \n",
       "1      本科及以上   5年以上  30-40k·12薪  2020年04月20日   \n",
       "2      硕士及以上   5年以上  18-25k·12薪  2020年04月20日   \n",
       "3      硕士及以上   5年以上          面议  2020年04月20日   \n",
       "4      大专及以上   5年以上  15-18k·12薪  2020年04月20日   \n",
       "5       统招本科   5年以上          面议  2020年04月20日   \n",
       "6      本科及以上   2年以上    6-8k·12薪  2020年04月20日   \n",
       "7      大专及以上   1年以上   6-10k·12薪  2020年04月20日   \n",
       "8      大专及以上   2年以上   8-12k·12薪  2020年04月20日   \n",
       "9      大专及以上   5年以上  13-16k·12薪  2020年04月20日   \n",
       "10     本科及以上   2年以上          面议  2020年04月20日   \n",
       "11     本科及以上   2年以上          面议  2020年04月20日   \n",
       "12     大专及以上   1年以上    3-5k·12薪  2020年04月20日   \n",
       "13     本科及以上   5年以上  10-20k·12薪  2020年04月20日   \n",
       "14     大专及以上   5年以上  12-16k·14薪  2020年04月20日   \n",
       "15     本科及以上   3年以上          面议  2020年04月20日   \n",
       "16     大专及以上   3年以上  10-15k·12薪  2020年04月20日   \n",
       "17      统招本科   1年以上    4-8k·12薪  2020年04月20日   \n",
       "18     大专及以上   经验不限    3-6k·12薪  2020年04月20日   \n",
       "19     本科及以上   5年以上  25-50k·12薪  2020年04月20日   \n",
       "20     大专及以上  10年以上          面议  2020年04月20日   \n",
       "21     大专及以上   5年以上  10-15k·12薪  2020年04月20日   \n",
       "22     大专及以上   5年以上          面议  2020年04月20日   \n",
       "23     大专及以上   经验不限   6-11k·12薪  2020年04月20日   \n",
       "24     本科及以上   5年以上  20-40k·15薪  2020年04月20日   \n",
       "25     大专及以上   1年以上    6-8k·12薪  2020年04月20日   \n",
       "26      统招本科   5年以上  15-25k·12薪  2020年04月20日   \n",
       "27      统招本科   5年以上          面议  2020年04月20日   \n",
       "28     本科及以上   2年以上    6-8k·12薪  2020年04月20日   \n",
       "29      统招本科   5年以上  20-35k·14薪  2020年04月20日   \n",
       "30     本科及以上   2年以上    6-8k·12薪  2020年04月20日   \n",
       "31     大专及以上   3年以上   7-10k·12薪  2020年04月20日   \n",
       "32      统招本科   3年以上          面议  2020年04月20日   \n",
       "33     本科及以上   2年以上    6-8k·12薪  2020年04月20日   \n",
       "34  中专/中技及以上  10年以上    4-5k·12薪  2020年04月20日   \n",
       "35     本科及以上   2年以上    5-8k·12薪  2020年04月20日   \n",
       "36      统招本科   5年以上  17-25k·16薪  2020年04月20日   \n",
       "37     本科及以上   2年以上    6-8k·12薪  2020年04月20日   \n",
       "38     本科及以上   5年以上          面议  2020年04月20日   \n",
       "39     大专及以上   1年以上   8-12k·12薪  2020年04月20日   \n",
       "\n",
       "                                    职称     公司地点                 公司名称  \\\n",
       "0                                 法务经理       北京                 唯医骨科   \n",
       "1                        商业集团-投资关系专业总监       上海                 弘阳集团   \n",
       "2                      资产监管（股权管理）-高级经理       北京          中国科学院控股有限公司   \n",
       "3                      资产监管（成果转化）-高级经理       北京          中国科学院控股有限公司   \n",
       "4                               电商运营经理       广州         广东骏丰频谱股份有限公司   \n",
       "5                               电商推广专家       北京                 国美控股   \n",
       "6                               财务人事经理       南京         南京启真基因工程有限公司   \n",
       "7                                php开发   长沙-雨花区         湖南象盒网络科技有限公司   \n",
       "8                            前端开发（vue）   长沙-雨花区         湖南象盒网络科技有限公司   \n",
       "9                          Java高级开发工程师   长沙-雨花区         湖南象盒网络科技有限公司   \n",
       "10                                债券销售    上海-塘桥                 浙商证券   \n",
       "11                              股权发行销售  上海-浦东新区                 浙商证券   \n",
       "12                                客服专员   温州-鹿城区       南京金融资产交易中心有限公司   \n",
       "13                             产业园招商经理       沈阳           沈阳万科企业有限公司   \n",
       "14                           火锅食材供应链专家       北京                 国美控股   \n",
       "15                               软件工程师                        泰邦生物集团   \n",
       "16               电商销售主管（经销商管理）(005303)       广州                   奥飞   \n",
       "17                               电商设计师   上海-长宁区         上海上室网络科技有限公司   \n",
       "18                                财务助理    上海-华漕         上海上室网络科技有限公司   \n",
       "19                       XOVE品牌中国区运营总监  广州-珠江新城         卓珈美容(香港)有限公司   \n",
       "20                               副总建筑师       武汉       湖北中天世纪工程技术有限公司   \n",
       "21                       中山区域呼叫中心主管/经理       中山                  雅居乐   \n",
       "22                            投资经理（无锡）    无锡-蠡湖      郑州康桥房地产开发有限责任公司   \n",
       "23                                销售顾问    武汉-永清  万仕道(北京)管理咨询有限公司华南大区   \n",
       "24                           解决方案高级工程师   广州-越秀区         丰图科技(深圳)有限公司   \n",
       "25                              售后服务专员       杭州                  快捷通   \n",
       "26                          商务经理（酒店方向）                  北京汉方智汇科技有限公司   \n",
       "27                                市场经理   武汉-江汉区      武汉中城悦城房地产开发有限公司   \n",
       "28                  工程造价专员1名（昭旺家居产投公司）       广元               同圣产业投资   \n",
       "29  Consulting Manager/ Senior Manager                 益普索(中国)咨询有限公司   \n",
       "30                  工程管理专员1名（昭旺家居产投公司）       广元               同圣产业投资   \n",
       "31                                招商主管       宁波       浙江驿淘科技产业服务有限公司   \n",
       "32                            云平台研发工程师       南京              大全电气研究院   \n",
       "33                  产业发展助理1名（昭旺家居产投公司）       广元               同圣产业投资   \n",
       "34                                 驾驶员       重庆          重庆川百达集团有限公司   \n",
       "35                    投资专员1名（昭旺家居产投公司）       广元               同圣产业投资   \n",
       "36                             软件测试工程师       北京                 汽车之家   \n",
       "37                    审计专员1名（昭旺家居产投公司）       广元               同圣产业投资   \n",
       "38                         店长（成都智能生活馆）   成都-牛市口                   华为   \n",
       "39                                财经编辑                北京双志伟业网络科技有限公司   \n",
       "\n",
       "                                             链结  \\\n",
       "0   https://www.liepin.com/job/1927600483.shtml   \n",
       "1   https://www.liepin.com/job/1927599825.shtml   \n",
       "2   https://www.liepin.com/job/1927599791.shtml   \n",
       "3   https://www.liepin.com/job/1927599755.shtml   \n",
       "4   https://www.liepin.com/job/1927599357.shtml   \n",
       "5   https://www.liepin.com/job/1927599315.shtml   \n",
       "6   https://www.liepin.com/job/1927599305.shtml   \n",
       "7   https://www.liepin.com/job/1927599165.shtml   \n",
       "8   https://www.liepin.com/job/1927599149.shtml   \n",
       "9   https://www.liepin.com/job/1927599125.shtml   \n",
       "10  https://www.liepin.com/job/1927598555.shtml   \n",
       "11  https://www.liepin.com/job/1927598479.shtml   \n",
       "12  https://www.liepin.com/job/1927598287.shtml   \n",
       "13  https://www.liepin.com/job/1927598037.shtml   \n",
       "14  https://www.liepin.com/job/1927597545.shtml   \n",
       "15  https://www.liepin.com/job/1927596409.shtml   \n",
       "16  https://www.liepin.com/job/1927596243.shtml   \n",
       "17  https://www.liepin.com/job/1927596135.shtml   \n",
       "18  https://www.liepin.com/job/1927595949.shtml   \n",
       "19  https://www.liepin.com/job/1927594873.shtml   \n",
       "20  https://www.liepin.com/job/1927594729.shtml   \n",
       "21  https://www.liepin.com/job/1927594399.shtml   \n",
       "22  https://www.liepin.com/job/1927594233.shtml   \n",
       "23  https://www.liepin.com/job/1927594175.shtml   \n",
       "24  https://www.liepin.com/job/1927593927.shtml   \n",
       "25  https://www.liepin.com/job/1927593739.shtml   \n",
       "26  https://www.liepin.com/job/1927593657.shtml   \n",
       "27  https://www.liepin.com/job/1927593615.shtml   \n",
       "28  https://www.liepin.com/job/1927593575.shtml   \n",
       "29  https://www.liepin.com/job/1927593525.shtml   \n",
       "30  https://www.liepin.com/job/1927593475.shtml   \n",
       "31  https://www.liepin.com/job/1927593415.shtml   \n",
       "32  https://www.liepin.com/job/1927593255.shtml   \n",
       "33  https://www.liepin.com/job/1927593191.shtml   \n",
       "34  https://www.liepin.com/job/1927593073.shtml   \n",
       "35  https://www.liepin.com/job/1927593031.shtml   \n",
       "36  https://www.liepin.com/job/1927592871.shtml   \n",
       "37  https://www.liepin.com/job/1927592869.shtml   \n",
       "38  https://www.liepin.com/job/1927592835.shtml   \n",
       "39  https://www.liepin.com/job/1927592317.shtml   \n",
       "\n",
       "                                       公司URL  \n",
       "0    https://www.liepin.com/company/8880538/  \n",
       "1     https://www.liepin.com/company/729252/  \n",
       "2    https://www.liepin.com/company/8639500/  \n",
       "3    https://www.liepin.com/company/8639500/  \n",
       "4    https://www.liepin.com/company/7939826/  \n",
       "5    https://www.liepin.com/company/3934494/  \n",
       "6    https://www.liepin.com/company/9640452/  \n",
       "7    https://www.liepin.com/company/9949751/  \n",
       "8    https://www.liepin.com/company/9949751/  \n",
       "9    https://www.liepin.com/company/9949751/  \n",
       "10   https://www.liepin.com/company/7873563/  \n",
       "11   https://www.liepin.com/company/7873563/  \n",
       "12   https://www.liepin.com/company/8978495/  \n",
       "13   https://www.liepin.com/company/9912521/  \n",
       "14   https://www.liepin.com/company/3934494/  \n",
       "15   https://www.liepin.com/company/9803471/  \n",
       "16   https://www.liepin.com/company/7875551/  \n",
       "17   https://www.liepin.com/company/9329710/  \n",
       "18   https://www.liepin.com/company/9329710/  \n",
       "19  https://www.liepin.com/company/12180385/  \n",
       "20   https://www.liepin.com/company/8122884/  \n",
       "21    https://www.liepin.com/company/185424/  \n",
       "22   https://www.liepin.com/company/8917793/  \n",
       "23   https://www.liepin.com/company/8388695/  \n",
       "24  https://www.liepin.com/company/12169397/  \n",
       "25   https://www.liepin.com/company/8002546/  \n",
       "26  https://www.liepin.com/company/10147775/  \n",
       "27   https://www.liepin.com/company/9733701/  \n",
       "28  https://www.liepin.com/company/12161893/  \n",
       "29    https://www.liepin.com/company/474099/  \n",
       "30  https://www.liepin.com/company/12161893/  \n",
       "31   https://www.liepin.com/company/9630336/  \n",
       "32   https://www.liepin.com/company/8975185/  \n",
       "33  https://www.liepin.com/company/12161893/  \n",
       "34   https://www.liepin.com/company/9617291/  \n",
       "35  https://www.liepin.com/company/12161893/  \n",
       "36    https://www.liepin.com/company/886182/  \n",
       "37  https://www.liepin.com/company/12161893/  \n",
       "38    https://www.liepin.com/company/954482/  \n",
       "39   https://www.liepin.com/company/8611423/  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# A-1   单一页面\n",
    "import pandas as pd\n",
    "from requests_html import HTMLSession\n",
    "session = HTMLSession()\n",
    "\n",
    "\n",
    "url = \"https://www.liepin.com/zhaopin/?keyword=PRD\"\n",
    "session = HTMLSession()\n",
    "r = session.get( url )\n",
    "\n",
    "# 先取特定元素, 精准打击其子后辈\n",
    "主要元素 = r.html.xpath( \\\n",
    "    '//ul[@class=\"sojob-list\"]/li')\n",
    "\n",
    "# 预期是一个元素的列表？\n",
    "#print (主要元素[0].xpath('//div[contains(@class,\"sojob-item-main\")]'))\n",
    "#print (主要元素[0].xpath('//div[contains(@class,\"job-info\")]/h3/a'))\n",
    "#print (主要元素[3].xpath('//div[contains(@class,\"job-info\")]/p/a'))\n",
    "#print (主要元素[3].xpath('//div[contains(@class,\"job-info\")]/p/span[@class=\"text-warning\"]'))\n",
    "#print (主要元素[3].xpath('//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]/following-sibling::span'))\n",
    "#print (主要元素[3].xpath('//div[contains(@class,\"job-info\")]/p/time/@title'))\n",
    "#print (主要元素[0].xpath('//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a'))\n",
    "\n",
    "# 作为xpath字典，键为我要抓的牛肉名称，值为xpath\n",
    "dict_xpaths={ \n",
    "    'text': {\n",
    "        'edu':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]',\n",
    "        '经验':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]/following-sibling::span',\n",
    "        '薪水':    '//div[contains(@class,\"job-info\")]/p/span[@class=\"text-warning\"]', \n",
    "        '时间':    '//div[contains(@class,\"job-info\")]/p/time/@title', \n",
    "        '职称':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "        '公司地点': '//div[contains(@class,\"job-info\")]/p/a',\n",
    "        '公司名称': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "    },\n",
    "    'text_content': {\n",
    "    },\n",
    "    'href': {\n",
    "        '链结':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "        '公司URL': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "    }\n",
    "}\n",
    "\n",
    "def get_e_text_content(_xpath_):\n",
    "    # 高级列表推导\n",
    "    暂存结果 = [e.xpath(_xpath_)[0].lxml.text_content() for e in 主要元素]\n",
    "    return(暂存结果)\n",
    "\n",
    "def get_e_text(_xpath_):\n",
    "    # 高级列表推导\n",
    "    暂存结果 = [\"\".join([x.strip() if type(x) is str else x.text.strip() for x in e.xpath(_xpath_)]) for e in 主要元素]\n",
    "    return(暂存结果)\n",
    "\n",
    "def get_e_href(_xpath_):\n",
    "    # 高级列表推导\n",
    "    暂存结果 = [list(e.xpath(_xpath_, first=True).absolute_links)[0] \\\n",
    "               if len(e.xpath(_xpath_, first=True).absolute_links) >= 1  \\\n",
    "               else \"\" for e in 主要元素]\n",
    "    return(暂存结果)\n",
    "\n",
    "# 只对主要元素下进行.xpath取值\n",
    "数据字典 = dict()\n",
    "\n",
    "数据字典 = {k:get_e_text_content(v) for k,v in dict_xpaths['text_content'].items()}\n",
    "数据字典.update({k:get_e_text(v) for k,v in dict_xpaths['text'].items()})\n",
    "数据字典.update({k:get_e_href(v) for k,v in dict_xpaths['href'].items()})\n",
    "\n",
    "[len(v) for k,v in 数据字典.items()]\n",
    "\n",
    "数据 = pd.DataFrame(数据字典)\n",
    "数据.to_excel(\"20春_Web数据挖掘_week03_liepin.xlsx\", sheet_name=\"搜查结果\")\n",
    "数据 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<Element 'div' class=('search-conditions',) data-selector='search-conditions'>]\n",
      "<Element 'div' class=('search-conditions',) data-selector='search-conditions'>\n",
      "[<Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>, <Element 'dt' class=('search-title',)>]\n",
      "公司：\n",
      "行业：\n",
      "城市：\n",
      "薪资：\n",
      "更多：\n",
      "<Element 'dd' class=('comp-list',)>\n",
      "<Element 'dd' class=('short-dd', 'select-industry') data-param='industries'>\n",
      "<Element 'dd' data-param='city'>\n",
      "<Element 'dd' data-param='salary'>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-time')>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-jobkind')>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-compscale')>\n",
      "<Element 'dd' class=('dropdown', 'dropdown-compkind')>\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'中国500强': '/zhaopin/?init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=155&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3',\n",
       " '2018互联网300强': '/zhaopin/?init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=182&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3',\n",
       " '制造业500强': '/zhaopin/?init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=186&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3',\n",
       " 'AI创新成长50强 ': '/zhaopin/?init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=189&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3',\n",
       " '独角兽': '/zhaopin/?init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=130&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3',\n",
       " '上市公司': '/zhaopin/?init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=156&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3'}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# A-2 扩张 公司 ?  \n",
    "\n",
    "# 先取特定元素, 精准打击其子后辈\n",
    "主要元素 = r.html.xpath('//div[@data-selector=\"search-conditions\"]')\n",
    "# 预期是一个元素的列表？\n",
    "print (主要元素)\n",
    "print (主要元素[0])\n",
    "print (主要元素[0].xpath('//dt[@class=\"search-title\"]'))\n",
    "\n",
    "list_search_title = 主要元素[0].xpath('//dt[@class=\"search-title\"]')\n",
    "for x in list_search_title:\n",
    "    print (x.text)\n",
    "    \n",
    "list_search_dd = 主要元素[0].xpath('//dt[@class=\"search-title\"]/following-sibling::dd')\n",
    "for x in list_search_dd:\n",
    "    print (x)  \n",
    "    \n",
    "\n",
    "公司数据选择器链结 = r.html.xpath('//div[@data-selector=\"search-conditions\"]')[0] \\\n",
    "                    .xpath('//dt[@class=\"search-title\"]/following-sibling::dd')[0] \\\n",
    "                    .xpath('//div[contains(@class,\"hot-comp-tags\")]/a/@href')\n",
    "               \n",
    "公司数据选择器链结\n",
    "\n",
    "# 但我们需要知道这些选择器链结, 对映到什麽数据\n",
    "公司数据选择器链结 = r.html.xpath('//div[@data-selector=\"search-conditions\"]')[0] \\\n",
    "                    .xpath('//dt[@class=\"search-title\"]/following-sibling::dd')[0] \\\n",
    "                    .xpath('//div[contains(@class,\"hot-comp-tags\")]/a')\n",
    "公司数据选择器链结\n",
    "\n",
    "#[ x.xpath(\"a/@href\")[0] for x in 公司数据选择器链结]\n",
    "#[ x.xpath(\"a/text()\")[0] for x in 公司数据选择器链结]\n",
    "公司数据选择器链结 = { x.xpath(\"a/text()\")[0]:x.xpath(\"a/@href\")[0] for x in 公司数据选择器链结}\n",
    "公司数据选择器链结"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=155&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=182&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=186&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=189&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=130&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3', fragment=''),\n",
       " ParseResult(scheme='', netloc='', path='/zhaopin/', params='', query='init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=PRD&compTag=156&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg%7EfA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3', fragment='')]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# B-1 使用 urllib.parse 解析\n",
    "from urllib.parse import urlparse, parse_qs\n",
    "[ urlparse(x) for x in 公司数据选择器链结.values()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 6 entries, 0 to 5\n",
      "Data columns (total 6 columns):\n",
      "scheme      6 non-null object\n",
      "netloc      6 non-null object\n",
      "path        6 non-null object\n",
      "params      6 non-null object\n",
      "query       6 non-null object\n",
      "fragment    6 non-null object\n",
      "dtypes: object(6)\n",
      "memory usage: 368.0+ bytes\n",
      "scheme      1\n",
      "netloc      1\n",
      "path        1\n",
      "params      1\n",
      "query       6\n",
      "fragment    1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>scheme</th>\n",
       "      <th>netloc</th>\n",
       "      <th>path</th>\n",
       "      <th>params</th>\n",
       "      <th>query</th>\n",
       "      <th>fragment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>/zhaopin/</td>\n",
       "      <td></td>\n",
       "      <td>init=-1&amp;headckid=be1c012f3f9d2d43&amp;flushckid=1&amp;...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  scheme netloc       path params  \\\n",
       "0                /zhaopin/          \n",
       "\n",
       "                                               query fragment  \n",
       "0  init=-1&headckid=be1c012f3f9d2d43&flushckid=1&...           "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# B-2 使用 pd.DataFrame进行 unuinque()相异值计量比对 \n",
    "import pandas as pd\n",
    "df = pd.DataFrame([ urlparse(x) for x in 公司数据选择器链结.values()])\n",
    "df.info()\n",
    "print(df.nunique())\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ckid             1\n",
      "compTag          6\n",
      "d_ckId           1\n",
      "d_curPage        1\n",
      "d_headId         1\n",
      "d_pageSize       1\n",
      "d_sfrom          1\n",
      "flushckid        1\n",
      "fromSearchBtn    1\n",
      "headckid         1\n",
      "init             1\n",
      "keyword          1\n",
      "siTag            1\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>keyword</th>\n",
       "      <th>compTag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PRD</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PRD</td>\n",
       "      <td>182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PRD</td>\n",
       "      <td>186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PRD</td>\n",
       "      <td>189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PRD</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PRD</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  keyword compTag\n",
       "0     PRD     155\n",
       "1     PRD     182\n",
       "2     PRD     186\n",
       "3     PRD     189\n",
       "4     PRD     130\n",
       "5     PRD     156"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# B-3 针对query 再解析之 \n",
    "#df_qs = pd.DataFrame([ parse_qs(x) for x in df['query'] ])\n",
    "df_qs = pd.DataFrame([{k:v[0] for k,v in parse_qs(x).items()} for x in df['query'] ])\n",
    "print (df_qs.nunique())\n",
    "df_qs.head()\n",
    "df_qs[['keyword','compTag']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[{'init': '-1', 'headckid': 'be1c012f3f9d2d43', 'flushckid': '1', 'fromSearchBtn': '2', 'keyword': 'PRD', 'compTag': '155', 'ckid': 'be1c012f3f9d2d43', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}, {'init': '-1', 'headckid': 'be1c012f3f9d2d43', 'flushckid': '1', 'fromSearchBtn': '2', 'keyword': 'PRD', 'compTag': '182', 'ckid': 'be1c012f3f9d2d43', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}, {'init': '-1', 'headckid': 'be1c012f3f9d2d43', 'flushckid': '1', 'fromSearchBtn': '2', 'keyword': 'PRD', 'compTag': '186', 'ckid': 'be1c012f3f9d2d43', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}, {'init': '-1', 'headckid': 'be1c012f3f9d2d43', 'flushckid': '1', 'fromSearchBtn': '2', 'keyword': 'PRD', 'compTag': '189', 'ckid': 'be1c012f3f9d2d43', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}, {'init': '-1', 'headckid': 'be1c012f3f9d2d43', 'flushckid': '1', 'fromSearchBtn': '2', 'keyword': 'PRD', 'compTag': '130', 'ckid': 'be1c012f3f9d2d43', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}, {'init': '-1', 'headckid': 'be1c012f3f9d2d43', 'flushckid': '1', 'fromSearchBtn': '2', 'keyword': 'PRD', 'compTag': '156', 'ckid': 'be1c012f3f9d2d43', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}] {'init': '-1', 'headckid': 'be1c012f3f9d2d43', 'flushckid': '1', 'fromSearchBtn': '2', 'keyword': 'PRD', 'compTag': '156', 'ckid': 'be1c012f3f9d2d43', 'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw', 'd_sfrom': 'search_unknown', 'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3', 'd_curPage': '0', 'd_pageSize': '40', 'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "\"python 原代碼以下不處理\\ndf_qs = pd.DataFrame(list_query)\\nprint (df_qs.nunique())\\ndf_qs.head()\\ndf_qs[['keyword','compTag']]\\n\""
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# B-3-X 对 B-3 代码的字典/列表推导的分拆说明\n",
    "\n",
    "# ----------------------------------------------\n",
    "# 列表暂存 = [{k:v[0] for k,v in parse_qs(q).items()} for q in df['query'] ]\n",
    "# 以下3行代碼相當於上面推導1行\n",
    "列表暂存 = [] # list()\n",
    "for x in df['query']: \n",
    "    列表暂存.append({k:v[0] for k,v in parse_qs(x).items()} )\n",
    "    \n",
    "# ----------------------------------------------\n",
    "# 字典暂存 = {k:v[0] for k,v in parse_qs(x).items()}\n",
    "# 以下3行代碼相當於上面推導1行\n",
    "字典暂存 = dict()\n",
    "for k,v in parse_qs(x).items():     # for 键,值 in 字典.items():\n",
    "    字典暂存.update({k:v[0]})\n",
    "    \n",
    "# ----------------------------------------------\n",
    "print (列表暂存, 字典暂存) \n",
    "\n",
    "'''python 原代碼以下不處理\n",
    "df_qs = pd.DataFrame(list_query)\n",
    "print (df_qs.nunique())\n",
    "df_qs.head()\n",
    "df_qs[['keyword','compTag']]\n",
    "'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'init': '-1',\n",
       "  'headckid': 'be1c012f3f9d2d43',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'keyword': 'PRD',\n",
       "  'compTag': '155',\n",
       "  'ckid': 'be1c012f3f9d2d43',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'},\n",
       " {'init': '-1',\n",
       "  'headckid': 'be1c012f3f9d2d43',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'keyword': 'PRD',\n",
       "  'compTag': '182',\n",
       "  'ckid': 'be1c012f3f9d2d43',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'},\n",
       " {'init': '-1',\n",
       "  'headckid': 'be1c012f3f9d2d43',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'keyword': 'PRD',\n",
       "  'compTag': '186',\n",
       "  'ckid': 'be1c012f3f9d2d43',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'},\n",
       " {'init': '-1',\n",
       "  'headckid': 'be1c012f3f9d2d43',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'keyword': 'PRD',\n",
       "  'compTag': '189',\n",
       "  'ckid': 'be1c012f3f9d2d43',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'},\n",
       " {'init': '-1',\n",
       "  'headckid': 'be1c012f3f9d2d43',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'keyword': 'PRD',\n",
       "  'compTag': '130',\n",
       "  'ckid': 'be1c012f3f9d2d43',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'},\n",
       " {'init': '-1',\n",
       "  'headckid': 'be1c012f3f9d2d43',\n",
       "  'flushckid': '1',\n",
       "  'fromSearchBtn': '2',\n",
       "  'keyword': 'PRD',\n",
       "  'compTag': '156',\n",
       "  'ckid': 'be1c012f3f9d2d43',\n",
       "  'siTag': '1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw',\n",
       "  'd_sfrom': 'search_unknown',\n",
       "  'd_ckId': '4e106134cc9f16b8b92041e60bf07ad3',\n",
       "  'd_curPage': '0',\n",
       "  'd_pageSize': '40',\n",
       "  'd_headId': '4e106134cc9f16b8b92041e60bf07ad3'}]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# B-3-XX 整合后\n",
    "\n",
    "列表暫存 = [] # list()\n",
    "for q in df['query']: \n",
    "    字典暫存 = dict()\n",
    "    for k,v in parse_qs(q).items(): # for 鍵,值 in 字典.items():\n",
    "        字典暫存.update({k:v[0]})\n",
    "    列表暫存.append(字典暫存)\n",
    "列表暫存\n",
    "# ----------------------------------------------\n",
    "# 比較\n",
    "# 列表暫存 = [{k:v[0] for k,v in parse_qs(q).items()} for q in df['query'] ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'init': ['-1'], 'headckid': ['be1c012f3f9d2d43'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['PRD'], 'compTag': ['155'], 'ckid': ['be1c012f3f9d2d43'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['4e106134cc9f16b8b92041e60bf07ad3'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['4e106134cc9f16b8b92041e60bf07ad3']}\n",
      "{'中国500强': '155', '2018互联网300强': '182', '制造业500强': '186', 'AI创新成长50强 ': '189', '独角兽': '130', '上市公司': '156'}\n"
     ]
    }
   ],
   "source": [
    "# B-4 建构 参数模板 及 字典_compTag\n",
    "def parse_url_qs_for_compTag (url):\n",
    "    six_parts = urlparse(url) \n",
    "    out = parse_qs(six_parts.query)\n",
    "    return (out)\n",
    "\n",
    "# parse_url_qs_for_compTag(list(公司数据选择器链结.values())[0])['compTag']\n",
    "参数模板 = parse_url_qs_for_compTag(list(公司数据选择器链结.values())[0])\n",
    "print(参数模板)\n",
    "# [ parse_url_qs_for_compTag(x)['compTag'] for x in 公司数据选择器链结.values()]\n",
    "[ parse_url_qs_for_compTag(x)['compTag'][0] for x in 公司数据选择器链结.values()]\n",
    "\n",
    "字典_compTag = { k:parse_url_qs_for_compTag(v)['compTag'][0] for k,v in 公司数据选择器链结.items()}\n",
    "print (字典_compTag)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'中国500强': {'init': ['-1'], 'headckid': ['be1c012f3f9d2d43'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['用户体验'], 'compTag': ['155'], 'ckid': ['be1c012f3f9d2d43'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['4e106134cc9f16b8b92041e60bf07ad3'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['4e106134cc9f16b8b92041e60bf07ad3']}, '2018互联网300强': {'init': ['-1'], 'headckid': ['be1c012f3f9d2d43'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['用户体验'], 'compTag': ['182'], 'ckid': ['be1c012f3f9d2d43'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['4e106134cc9f16b8b92041e60bf07ad3'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['4e106134cc9f16b8b92041e60bf07ad3']}, '制造业500强': {'init': ['-1'], 'headckid': ['be1c012f3f9d2d43'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['用户体验'], 'compTag': ['186'], 'ckid': ['be1c012f3f9d2d43'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['4e106134cc9f16b8b92041e60bf07ad3'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['4e106134cc9f16b8b92041e60bf07ad3']}, 'AI创新成长50强 ': {'init': ['-1'], 'headckid': ['be1c012f3f9d2d43'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['用户体验'], 'compTag': ['189'], 'ckid': ['be1c012f3f9d2d43'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['4e106134cc9f16b8b92041e60bf07ad3'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['4e106134cc9f16b8b92041e60bf07ad3']}, '独角兽': {'init': ['-1'], 'headckid': ['be1c012f3f9d2d43'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['用户体验'], 'compTag': ['130'], 'ckid': ['be1c012f3f9d2d43'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['4e106134cc9f16b8b92041e60bf07ad3'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['4e106134cc9f16b8b92041e60bf07ad3']}, '上市公司': {'init': ['-1'], 'headckid': ['be1c012f3f9d2d43'], 'flushckid': ['1'], 'fromSearchBtn': ['2'], 'keyword': ['用户体验'], 'compTag': ['156'], 'ckid': ['be1c012f3f9d2d43'], 'siTag': ['1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw'], 'd_sfrom': ['search_unknown'], 'd_ckId': ['4e106134cc9f16b8b92041e60bf07ad3'], 'd_curPage': ['0'], 'd_pageSize': ['40'], 'd_headId': ['4e106134cc9f16b8b92041e60bf07ad3']}}\n"
     ]
    }
   ],
   "source": [
    "# B-5 建构 参数模板  \n",
    "def 参数模板生成(compTag , keyword ):\n",
    "    参数 = 参数模板.copy()\n",
    "    参数['compTag'] = compTag\n",
    "    参数['keyword'] = keyword\n",
    "    return (参数)\n",
    "\n",
    "参数_compTag_用户体验 = { k:参数模板生成(compTag = [v], keyword = ['用户体验']) for k,v in 字典_compTag.items()}\n",
    "print(参数_compTag_用户体验)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://www.liepin.com/zhaopin/?init=-1&headckid=be1c012f3f9d2d43&flushckid=1&fromSearchBtn=2&keyword=%E7%94%A8%E6%88%B7%E4%BD%93%E9%AA%8C&compTag=182&ckid=be1c012f3f9d2d43&siTag=1B2M2Y8AsgTpgAmY7PhCfg~fA9rXquZc5IkJpXC-Ycixw&d_sfrom=search_unknown&d_ckId=4e106134cc9f16b8b92041e60bf07ad3&d_curPage=0&d_pageSize=40&d_headId=4e106134cc9f16b8b92041e60bf07ad3'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# C-1   多个页面准备测试1 中国500强\n",
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "session = HTMLSession()\n",
    "payload = 参数_compTag_用户体验['2018互联网300强']\n",
    "r = session.get( url, params = payload)\n",
    "r.url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# C-2  简化 A-1   单一页面爬+解析\n",
    "session = HTMLSession()\n",
    "\n",
    "def requests_liepin( url, params):\n",
    "    r = session.get( url , params = payload)\n",
    "\n",
    "    # 先取特定元素, 精准打击其子后辈\n",
    "    主要元素 = r.html.xpath( '//ul[@class=\"sojob-list\"]/li')\n",
    "\n",
    "    # 作为xpath字典，键为我要抓的牛肉名称，值为xpath\n",
    "    dict_xpaths={ \n",
    "        'text': {\n",
    "            'edu':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]',\n",
    "            '经验':      '//div[contains(@class,\"job-info\")]/p/span[@class=\"edu\"]/following-sibling::span',\n",
    "            '薪水':    '//div[contains(@class,\"job-info\")]/p/span[@class=\"text-warning\"]', \n",
    "            '时间':    '//div[contains(@class,\"job-info\")]/p/time/@title', \n",
    "            '职称':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司地点': '//div[contains(@class,\"job-info\")]/p/a',\n",
    "            '公司名称': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        },\n",
    "        'text_content': {\n",
    "        },\n",
    "        'href': {\n",
    "            '链结':    '//div[contains(@class,\"job-info\")]/h3/a', \n",
    "            '公司URL': '//div[contains(@class,\"sojob-item-main\")]//p[@class=\"company-name\"]/a', \n",
    "        }\n",
    "    }\n",
    "\n",
    "    def get_e_text_content(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [e.xpath(_xpath_)[0].lxml.text_content() for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_text(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [\"\".join([x.strip() if type(x) is str else x.text.strip() for x in e.xpath(_xpath_)]) for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    def get_e_href(_xpath_):\n",
    "        # 高级列表推导\n",
    "        暂存结果 = [list(e.xpath(_xpath_, first=True).absolute_links)[0] \\\n",
    "                   if len(e.xpath(_xpath_, first=True).absolute_links) >= 1  \\\n",
    "                   else \"\" for e in 主要元素]\n",
    "        return(暂存结果)\n",
    "\n",
    "    # 只对主要元素下进行.xpath取值\n",
    "    数据字典 = dict()\n",
    "\n",
    "    数据字典 = {k:get_e_text_content(v) for k,v in dict_xpaths['text_content'].items()}\n",
    "    数据字典.update({k:get_e_text(v) for k,v in dict_xpaths['text'].items()})\n",
    "    数据字典.update({k:get_e_href(v) for k,v in dict_xpaths['href'].items()})\n",
    "\n",
    "    数据 = pd.DataFrame(数据字典)\n",
    "    #数据.to_excel(\"20春_Web数据挖掘_week03_liepin.xlsx\", sheet_name=\"搜查结果\")\n",
    "    return (数据)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>edu</th>\n",
       "      <th>经验</th>\n",
       "      <th>薪水</th>\n",
       "      <th>时间</th>\n",
       "      <th>职称</th>\n",
       "      <th>公司地点</th>\n",
       "      <th>公司名称</th>\n",
       "      <th>链结</th>\n",
       "      <th>公司URL</th>\n",
       "      <th>热门公司类型</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>30-40k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>商业集团-投资关系专业总监</td>\n",
       "      <td>上海</td>\n",
       "      <td>弘阳集团</td>\n",
       "      <td>https://www.liepin.com/job/1927599825.shtml</td>\n",
       "      <td>https://www.liepin.com/company/729252/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>资深栏目运营</td>\n",
       "      <td>杭州</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927388909.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>20-35k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>税务筹划专家</td>\n",
       "      <td>郑州</td>\n",
       "      <td>郑州宇通集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927303523.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1530833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>25-45k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>饮料总经理</td>\n",
       "      <td>北京</td>\n",
       "      <td>达利食品</td>\n",
       "      <td>https://www.liepin.com/job/1927577627.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8381953/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>30-50k·16薪</td>\n",
       "      <td>2020年04月16日</td>\n",
       "      <td>数据技术及产品部-数据研发专家-数据资产平台</td>\n",
       "      <td>杭州-余杭区</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927492123.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月16日</td>\n",
       "      <td>达标车型认证岗</td>\n",
       "      <td>济南-高新区</td>\n",
       "      <td>中国重型汽车集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927181655.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9739005/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>30-50k·12薪</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>集团总部投资总监</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>禹洲地产股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927409715.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2245242/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>25-50k·12薪</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>课程研发负责人</td>\n",
       "      <td>上海-罗店</td>\n",
       "      <td>中国金茂控股集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926937565.shtml</td>\n",
       "      <td>https://www.liepin.com/company/6990643/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>85-115k·12薪</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>执行校长</td>\n",
       "      <td>上海-宝山区</td>\n",
       "      <td>中国金茂控股集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926933163.shtml</td>\n",
       "      <td>https://www.liepin.com/company/6990643/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>海外商务经理</td>\n",
       "      <td></td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1924796421.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月03日</td>\n",
       "      <td>广告销售大客户经理</td>\n",
       "      <td></td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1919211941.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>15-25k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>员工关系主管</td>\n",
       "      <td>杭州</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927601137.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>15-25k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>高级/资深人力资源专员</td>\n",
       "      <td>广州</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927601099.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>15-30k·14薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>移动生态战略规划部_大数据研发工程师</td>\n",
       "      <td>北京</td>\n",
       "      <td>Baidu</td>\n",
       "      <td>https://www.liepin.com/job/1927601013.shtml</td>\n",
       "      <td>https://www.liepin.com/company/884492/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>15-30k·14薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>移动生态战略规划部_数据挖掘工程师</td>\n",
       "      <td>北京</td>\n",
       "      <td>Baidu</td>\n",
       "      <td>https://www.liepin.com/job/1927601003.shtml</td>\n",
       "      <td>https://www.liepin.com/company/884492/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>8年以上</td>\n",
       "      <td>40-70k·14薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>商业运营平台部_CRM产品架构师</td>\n",
       "      <td>北京</td>\n",
       "      <td>Baidu</td>\n",
       "      <td>https://www.liepin.com/job/1927600991.shtml</td>\n",
       "      <td>https://www.liepin.com/company/884492/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>阿里云智能事业群-IoT-业务拓展专家（数字商业/金融）</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600923.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>董事会支持英文岗</td>\n",
       "      <td></td>\n",
       "      <td>中国国际金融股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927600913.shtml</td>\n",
       "      <td>https://www.liepin.com/company/4580900/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>30-60k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>OceanBase数据库SQL引擎研发专家</td>\n",
       "      <td></td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600897.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>20-35k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>OceanBase数据库SQL引擎研发工程师</td>\n",
       "      <td></td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600891.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>30-60k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>OceanBase数据库SQL引擎研发专家</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600885.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>20-35k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>OceanBase数据库SQL引擎研发工程师</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600861.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>阿里云智能事业群-IoT-解决方案架构师(零售/农业)</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600821.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>集团客户体验事业部-解决方案专家-商家服务赋能-淘系售前服务解决方案</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600819.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>8年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>阿里云智能-政府解决方案架构师-市场监管-北京</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600817.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-20k·14薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>高级运维工程师 - 有道事业群710</td>\n",
       "      <td>北京</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927600455.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>7年以上</td>\n",
       "      <td>35-60k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>ACG智慧政务事业部_商务合作经理</td>\n",
       "      <td>北京</td>\n",
       "      <td>Baidu</td>\n",
       "      <td>https://www.liepin.com/job/1927600445.shtml</td>\n",
       "      <td>https://www.liepin.com/company/884492/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>7年以上</td>\n",
       "      <td>35-60k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>ACG智慧政务事业部_商务合作经理</td>\n",
       "      <td>上海</td>\n",
       "      <td>Baidu</td>\n",
       "      <td>https://www.liepin.com/job/1927600443.shtml</td>\n",
       "      <td>https://www.liepin.com/company/884492/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-20k·16薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>动捕技术师/动作捕捉数据师/TA（动捕方向）/动作捕捉开发工程师/3D技术师</td>\n",
       "      <td>杭州</td>\n",
       "      <td>网易集团</td>\n",
       "      <td>https://www.liepin.com/job/1927600423.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5964833/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>蚂蚁集团-数据解决方案专家/高级专家-（上海/杭州）</td>\n",
       "      <td>杭州</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927600397.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>中国500强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>25-45k·12薪</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>饮料总经理</td>\n",
       "      <td>北京</td>\n",
       "      <td>达利食品</td>\n",
       "      <td>https://www.liepin.com/job/1927577627.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8381953/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>采购经理/工程师</td>\n",
       "      <td>深圳</td>\n",
       "      <td>中国南玻集团股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927470543.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9091167/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>6年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月20日</td>\n",
       "      <td>审计经理(005012)</td>\n",
       "      <td>广州</td>\n",
       "      <td>奥飞</td>\n",
       "      <td>https://www.liepin.com/job/1924129373.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7875551/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月19日</td>\n",
       "      <td>小学数学明星教师【保薪12-30万】</td>\n",
       "      <td>济南-市中区</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927480347.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>5-8k·12薪</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>法务专员</td>\n",
       "      <td>沈阳-市府</td>\n",
       "      <td>微贷</td>\n",
       "      <td>https://www.liepin.com/job/1927541985.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8597281/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>学历不限</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>户外媒体销售</td>\n",
       "      <td>广州-太和</td>\n",
       "      <td>华录百纳影视</td>\n",
       "      <td>https://www.liepin.com/job/1927533399.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7912451/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>项目销售高级主管</td>\n",
       "      <td></td>\n",
       "      <td>欧普照明</td>\n",
       "      <td>https://www.liepin.com/job/1927532661.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1566181/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>30-40k·12薪</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>俄罗斯销售总监（中亚）</td>\n",
       "      <td></td>\n",
       "      <td>柳工机械</td>\n",
       "      <td>https://www.liepin.com/job/1927519415.shtml</td>\n",
       "      <td>https://www.liepin.com/company/719708/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>技术支持专员</td>\n",
       "      <td>宜春</td>\n",
       "      <td>仁和集团</td>\n",
       "      <td>https://www.liepin.com/job/1927470809.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7327543/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>法务经理</td>\n",
       "      <td>深圳</td>\n",
       "      <td>富银融资租赁</td>\n",
       "      <td>https://www.liepin.com/job/1925146971.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8904607/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>8-20k·12薪</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>高中物理教师</td>\n",
       "      <td>贵阳-云岩区</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1919826941.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月17日</td>\n",
       "      <td>系统开发专家</td>\n",
       "      <td>北京</td>\n",
       "      <td>美团点评</td>\n",
       "      <td>https://www.liepin.com/job/1927546457.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2036768/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>1年以上</td>\n",
       "      <td>6-8k·12薪</td>\n",
       "      <td>2020年04月16日</td>\n",
       "      <td>商务专员（供应链）</td>\n",
       "      <td>上海-浦东新区</td>\n",
       "      <td>畅联股份</td>\n",
       "      <td>https://www.liepin.com/job/1927492479.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8712008/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>30-50k·16薪</td>\n",
       "      <td>2020年04月16日</td>\n",
       "      <td>数据技术及产品部-数据研发专家-数据资产平台</td>\n",
       "      <td>杭州-余杭区</td>\n",
       "      <td>阿里巴巴</td>\n",
       "      <td>https://www.liepin.com/job/1927492123.shtml</td>\n",
       "      <td>https://www.liepin.com/company/1072424/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>10-15k·12薪</td>\n",
       "      <td>2020年04月16日</td>\n",
       "      <td>总裁办秘书</td>\n",
       "      <td>上海-徐家汇</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927460427.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>10-13k·12薪</td>\n",
       "      <td>2020年04月15日</td>\n",
       "      <td>法务专员(J11102)</td>\n",
       "      <td>杭州</td>\n",
       "      <td>微贷</td>\n",
       "      <td>https://www.liepin.com/job/1927470925.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8597281/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月15日</td>\n",
       "      <td>税务专员(J11101)</td>\n",
       "      <td>杭州-下城区</td>\n",
       "      <td>微贷</td>\n",
       "      <td>https://www.liepin.com/job/1927470269.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8597281/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月15日</td>\n",
       "      <td>Android工程师(J11100)</td>\n",
       "      <td>杭州-下城区</td>\n",
       "      <td>微贷</td>\n",
       "      <td>https://www.liepin.com/job/1927469381.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8597281/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>经验不限</td>\n",
       "      <td>15-25k·12薪</td>\n",
       "      <td>2020年04月15日</td>\n",
       "      <td>信息安全</td>\n",
       "      <td>杭州</td>\n",
       "      <td>51信用卡管家</td>\n",
       "      <td>https://www.liepin.com/job/1927449223.shtml</td>\n",
       "      <td>https://www.liepin.com/company/6612666/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>8-10k·14薪</td>\n",
       "      <td>2020年04月15日</td>\n",
       "      <td>高级市场专员</td>\n",
       "      <td>大连-东软</td>\n",
       "      <td>猎聘</td>\n",
       "      <td>https://www.liepin.com/job/1927471547.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7873694/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>15-30k·12薪</td>\n",
       "      <td>2020年04月14日</td>\n",
       "      <td>市场前策高级专业经理</td>\n",
       "      <td></td>\n",
       "      <td>新城控股集团住宅开发事业部</td>\n",
       "      <td>https://www.liepin.com/job/1927439789.shtml</td>\n",
       "      <td>https://www.liepin.com/company/442197/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>2年以上</td>\n",
       "      <td>5-8k·12薪</td>\n",
       "      <td>2020年04月14日</td>\n",
       "      <td>行政专员（拉萨）</td>\n",
       "      <td>拉萨-堆龙德庆区</td>\n",
       "      <td>华钰矿业</td>\n",
       "      <td>https://www.liepin.com/job/1927423875.shtml</td>\n",
       "      <td>https://www.liepin.com/company/5865181/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>4年以上</td>\n",
       "      <td>12-18k·12薪</td>\n",
       "      <td>2020年04月14日</td>\n",
       "      <td>教学管理主管</td>\n",
       "      <td>武汉-武昌区</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926698165.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月14日</td>\n",
       "      <td>教学产品经理</td>\n",
       "      <td>武汉-武昌区</td>\n",
       "      <td>新东方教育科技集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926694451.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2485876/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>16-41k·12薪</td>\n",
       "      <td>2020年04月14日</td>\n",
       "      <td>私人财富管家/私人银行理财经理</td>\n",
       "      <td>太原-三桥</td>\n",
       "      <td>山西证券</td>\n",
       "      <td>https://www.liepin.com/job/1923874779.shtml</td>\n",
       "      <td>https://www.liepin.com/company/8538316/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>统招本科</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>30-50k·12薪</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>集团总部投资总监</td>\n",
       "      <td>深圳-南山区</td>\n",
       "      <td>禹洲地产股份有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1927409715.shtml</td>\n",
       "      <td>https://www.liepin.com/company/2245242/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>8年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>人力资源总监/高级经理（储备干部）</td>\n",
       "      <td>武汉-东西湖区</td>\n",
       "      <td>远大诺康</td>\n",
       "      <td>https://www.liepin.com/job/1927390671.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9610439/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>本科及以上</td>\n",
       "      <td>8年以上</td>\n",
       "      <td>面议</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>人力资源总监/高级经理（储备干部）</td>\n",
       "      <td>沈阳-浑南区</td>\n",
       "      <td>远大诺康</td>\n",
       "      <td>https://www.liepin.com/job/1927390669.shtml</td>\n",
       "      <td>https://www.liepin.com/company/9610439/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>大专及以上</td>\n",
       "      <td>3年以上</td>\n",
       "      <td>8-12k·13薪</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>视觉设计主管(005293)</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>奥飞</td>\n",
       "      <td>https://www.liepin.com/job/1927319263.shtml</td>\n",
       "      <td>https://www.liepin.com/company/7875551/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>硕士及以上</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>25-50k·12薪</td>\n",
       "      <td>2020年04月13日</td>\n",
       "      <td>课程研发负责人</td>\n",
       "      <td>上海-罗店</td>\n",
       "      <td>中国金茂控股集团有限公司</td>\n",
       "      <td>https://www.liepin.com/job/1926937565.shtml</td>\n",
       "      <td>https://www.liepin.com/company/6990643/</td>\n",
       "      <td>上市公司</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>240 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      edu     经验           薪水           时间  \\\n",
       "0   本科及以上   5年以上   30-40k·12薪  2020年04月20日   \n",
       "1   本科及以上   5年以上           面议  2020年04月20日   \n",
       "2   本科及以上   5年以上   20-35k·12薪  2020年04月20日   \n",
       "3   大专及以上  10年以上   25-45k·12薪  2020年04月20日   \n",
       "4   本科及以上   3年以上   30-50k·16薪  2020年04月16日   \n",
       "5    统招本科   经验不限           面议  2020年04月16日   \n",
       "6    统招本科   5年以上   30-50k·12薪  2020年04月13日   \n",
       "7   硕士及以上  10年以上   25-50k·12薪  2020年04月13日   \n",
       "8   硕士及以上  10年以上  85-115k·12薪  2020年04月13日   \n",
       "9   本科及以上   1年以上           面议  2020年04月03日   \n",
       "10  大专及以上   2年以上           面议  2020年04月03日   \n",
       "11  本科及以上   5年以上   15-25k·16薪  2020年04月20日   \n",
       "12  本科及以上   5年以上   15-25k·16薪  2020年04月20日   \n",
       "13   统招本科   2年以上   15-30k·14薪  2020年04月20日   \n",
       "14   统招本科   2年以上   15-30k·14薪  2020年04月20日   \n",
       "15   统招本科   8年以上   40-70k·14薪  2020年04月20日   \n",
       "16   学历不限   5年以上           面议  2020年04月20日   \n",
       "17  硕士及以上   经验不限           面议  2020年04月20日   \n",
       "18  本科及以上   经验不限   30-60k·16薪  2020年04月20日   \n",
       "19  本科及以上   经验不限   20-35k·16薪  2020年04月20日   \n",
       "20  本科及以上   经验不限   30-60k·16薪  2020年04月20日   \n",
       "21  本科及以上   经验不限   20-35k·16薪  2020年04月20日   \n",
       "22   学历不限   5年以上           面议  2020年04月20日   \n",
       "23   学历不限   5年以上           面议  2020年04月20日   \n",
       "24   学历不限   8年以上           面议  2020年04月20日   \n",
       "25   学历不限   经验不限   15-20k·14薪  2020年04月20日   \n",
       "26  本科及以上   7年以上   35-60k·12薪  2020年04月20日   \n",
       "27  本科及以上   7年以上   35-60k·12薪  2020年04月20日   \n",
       "28  本科及以上   经验不限   15-20k·16薪  2020年04月20日   \n",
       "29   学历不限   3年以上           面议  2020年04月20日   \n",
       "..    ...    ...          ...          ...   \n",
       "10  大专及以上  10年以上   25-45k·12薪  2020年04月20日   \n",
       "11  本科及以上   5年以上           面议  2020年04月20日   \n",
       "12  本科及以上   6年以上           面议  2020年04月20日   \n",
       "13   统招本科   经验不限   10-15k·12薪  2020年04月19日   \n",
       "14   统招本科   3年以上     5-8k·12薪  2020年04月17日   \n",
       "15   学历不限   3年以上           面议  2020年04月17日   \n",
       "16  大专及以上   3年以上   10-15k·12薪  2020年04月17日   \n",
       "17  本科及以上   5年以上   30-40k·12薪  2020年04月17日   \n",
       "18  大专及以上   1年以上           面议  2020年04月17日   \n",
       "19   统招本科   3年以上           面议  2020年04月17日   \n",
       "20  本科及以上   1年以上    8-20k·12薪  2020年04月17日   \n",
       "21  本科及以上   5年以上           面议  2020年04月17日   \n",
       "22  本科及以上   1年以上     6-8k·12薪  2020年04月16日   \n",
       "23  本科及以上   3年以上   30-50k·16薪  2020年04月16日   \n",
       "24  硕士及以上   经验不限   10-15k·12薪  2020年04月16日   \n",
       "25  本科及以上   3年以上   10-13k·12薪  2020年04月15日   \n",
       "26  本科及以上   3年以上           面议  2020年04月15日   \n",
       "27  大专及以上   3年以上           面议  2020年04月15日   \n",
       "28  本科及以上   经验不限   15-25k·12薪  2020年04月15日   \n",
       "29  大专及以上   3年以上    8-10k·14薪  2020年04月15日   \n",
       "30  本科及以上   5年以上   15-30k·12薪  2020年04月14日   \n",
       "31  本科及以上   2年以上     5-8k·12薪  2020年04月14日   \n",
       "32   统招本科   4年以上   12-18k·12薪  2020年04月14日   \n",
       "33   统招本科   5年以上           面议  2020年04月14日   \n",
       "34   统招本科   3年以上   16-41k·12薪  2020年04月14日   \n",
       "35   统招本科   5年以上   30-50k·12薪  2020年04月13日   \n",
       "36  本科及以上   8年以上           面议  2020年04月13日   \n",
       "37  本科及以上   8年以上           面议  2020年04月13日   \n",
       "38  大专及以上   3年以上    8-12k·13薪  2020年04月13日   \n",
       "39  硕士及以上  10年以上   25-50k·12薪  2020年04月13日   \n",
       "\n",
       "                                        职称      公司地点           公司名称  \\\n",
       "0                            商业集团-投资关系专业总监        上海           弘阳集团   \n",
       "1                                   资深栏目运营        杭州           网易集团   \n",
       "2                                   税务筹划专家        郑州     郑州宇通集团有限公司   \n",
       "3                                    饮料总经理        北京           达利食品   \n",
       "4                   数据技术及产品部-数据研发专家-数据资产平台    杭州-余杭区           阿里巴巴   \n",
       "5                                  达标车型认证岗    济南-高新区   中国重型汽车集团有限公司   \n",
       "6                                 集团总部投资总监    深圳-南山区     禹洲地产股份有限公司   \n",
       "7                                  课程研发负责人     上海-罗店   中国金茂控股集团有限公司   \n",
       "8                                     执行校长    上海-宝山区   中国金茂控股集团有限公司   \n",
       "9                                   海外商务经理                     网易集团   \n",
       "10                               广告销售大客户经理                     网易集团   \n",
       "11                                  员工关系主管        杭州           网易集团   \n",
       "12                             高级/资深人力资源专员        广州           网易集团   \n",
       "13                      移动生态战略规划部_大数据研发工程师        北京          Baidu   \n",
       "14                       移动生态战略规划部_数据挖掘工程师        北京          Baidu   \n",
       "15                        商业运营平台部_CRM产品架构师        北京          Baidu   \n",
       "16            阿里云智能事业群-IoT-业务拓展专家（数字商业/金融）        杭州           阿里巴巴   \n",
       "17                                董事会支持英文岗             中国国际金融股份有限公司   \n",
       "18                   OceanBase数据库SQL引擎研发专家                     阿里巴巴   \n",
       "19                  OceanBase数据库SQL引擎研发工程师                     阿里巴巴   \n",
       "20                   OceanBase数据库SQL引擎研发专家   上海-浦东新区           阿里巴巴   \n",
       "21                  OceanBase数据库SQL引擎研发工程师   上海-浦东新区           阿里巴巴   \n",
       "22             阿里云智能事业群-IoT-解决方案架构师(零售/农业)        杭州           阿里巴巴   \n",
       "23      集团客户体验事业部-解决方案专家-商家服务赋能-淘系售前服务解决方案        杭州           阿里巴巴   \n",
       "24                 阿里云智能-政府解决方案架构师-市场监管-北京        杭州           阿里巴巴   \n",
       "25                      高级运维工程师 - 有道事业群710        北京           网易集团   \n",
       "26                       ACG智慧政务事业部_商务合作经理        北京          Baidu   \n",
       "27                       ACG智慧政务事业部_商务合作经理        上海          Baidu   \n",
       "28  动捕技术师/动作捕捉数据师/TA（动捕方向）/动作捕捉开发工程师/3D技术师        杭州           网易集团   \n",
       "29              蚂蚁集团-数据解决方案专家/高级专家-（上海/杭州）        杭州           阿里巴巴   \n",
       "..                                     ...       ...            ...   \n",
       "10                                   饮料总经理        北京           达利食品   \n",
       "11                                采购经理/工程师        深圳   中国南玻集团股份有限公司   \n",
       "12                            审计经理(005012)        广州             奥飞   \n",
       "13                      小学数学明星教师【保薪12-30万】    济南-市中区  新东方教育科技集团有限公司   \n",
       "14                                    法务专员     沈阳-市府             微贷   \n",
       "15                                  户外媒体销售     广州-太和         华录百纳影视   \n",
       "16                                项目销售高级主管                     欧普照明   \n",
       "17                             俄罗斯销售总监（中亚）                     柳工机械   \n",
       "18                                  技术支持专员        宜春           仁和集团   \n",
       "19                                    法务经理        深圳         富银融资租赁   \n",
       "20                                  高中物理教师    贵阳-云岩区  新东方教育科技集团有限公司   \n",
       "21                                  系统开发专家        北京           美团点评   \n",
       "22                               商务专员（供应链）   上海-浦东新区           畅联股份   \n",
       "23                  数据技术及产品部-数据研发专家-数据资产平台    杭州-余杭区           阿里巴巴   \n",
       "24                                   总裁办秘书    上海-徐家汇  新东方教育科技集团有限公司   \n",
       "25                            法务专员(J11102)        杭州             微贷   \n",
       "26                            税务专员(J11101)    杭州-下城区             微贷   \n",
       "27                      Android工程师(J11100)    杭州-下城区             微贷   \n",
       "28                                    信息安全        杭州        51信用卡管家   \n",
       "29                                  高级市场专员     大连-东软             猎聘   \n",
       "30                              市场前策高级专业经理            新城控股集团住宅开发事业部   \n",
       "31                                行政专员（拉萨）  拉萨-堆龙德庆区           华钰矿业   \n",
       "32                                  教学管理主管    武汉-武昌区  新东方教育科技集团有限公司   \n",
       "33                                  教学产品经理    武汉-武昌区  新东方教育科技集团有限公司   \n",
       "34                         私人财富管家/私人银行理财经理     太原-三桥           山西证券   \n",
       "35                                集团总部投资总监    深圳-南山区     禹洲地产股份有限公司   \n",
       "36                       人力资源总监/高级经理（储备干部）   武汉-东西湖区           远大诺康   \n",
       "37                       人力资源总监/高级经理（储备干部）    沈阳-浑南区           远大诺康   \n",
       "38                          视觉设计主管(005293)    广州-天河区             奥飞   \n",
       "39                                 课程研发负责人     上海-罗店   中国金茂控股集团有限公司   \n",
       "\n",
       "                                             链结  \\\n",
       "0   https://www.liepin.com/job/1927599825.shtml   \n",
       "1   https://www.liepin.com/job/1927388909.shtml   \n",
       "2   https://www.liepin.com/job/1927303523.shtml   \n",
       "3   https://www.liepin.com/job/1927577627.shtml   \n",
       "4   https://www.liepin.com/job/1927492123.shtml   \n",
       "5   https://www.liepin.com/job/1927181655.shtml   \n",
       "6   https://www.liepin.com/job/1927409715.shtml   \n",
       "7   https://www.liepin.com/job/1926937565.shtml   \n",
       "8   https://www.liepin.com/job/1926933163.shtml   \n",
       "9   https://www.liepin.com/job/1924796421.shtml   \n",
       "10  https://www.liepin.com/job/1919211941.shtml   \n",
       "11  https://www.liepin.com/job/1927601137.shtml   \n",
       "12  https://www.liepin.com/job/1927601099.shtml   \n",
       "13  https://www.liepin.com/job/1927601013.shtml   \n",
       "14  https://www.liepin.com/job/1927601003.shtml   \n",
       "15  https://www.liepin.com/job/1927600991.shtml   \n",
       "16  https://www.liepin.com/job/1927600923.shtml   \n",
       "17  https://www.liepin.com/job/1927600913.shtml   \n",
       "18  https://www.liepin.com/job/1927600897.shtml   \n",
       "19  https://www.liepin.com/job/1927600891.shtml   \n",
       "20  https://www.liepin.com/job/1927600885.shtml   \n",
       "21  https://www.liepin.com/job/1927600861.shtml   \n",
       "22  https://www.liepin.com/job/1927600821.shtml   \n",
       "23  https://www.liepin.com/job/1927600819.shtml   \n",
       "24  https://www.liepin.com/job/1927600817.shtml   \n",
       "25  https://www.liepin.com/job/1927600455.shtml   \n",
       "26  https://www.liepin.com/job/1927600445.shtml   \n",
       "27  https://www.liepin.com/job/1927600443.shtml   \n",
       "28  https://www.liepin.com/job/1927600423.shtml   \n",
       "29  https://www.liepin.com/job/1927600397.shtml   \n",
       "..                                          ...   \n",
       "10  https://www.liepin.com/job/1927577627.shtml   \n",
       "11  https://www.liepin.com/job/1927470543.shtml   \n",
       "12  https://www.liepin.com/job/1924129373.shtml   \n",
       "13  https://www.liepin.com/job/1927480347.shtml   \n",
       "14  https://www.liepin.com/job/1927541985.shtml   \n",
       "15  https://www.liepin.com/job/1927533399.shtml   \n",
       "16  https://www.liepin.com/job/1927532661.shtml   \n",
       "17  https://www.liepin.com/job/1927519415.shtml   \n",
       "18  https://www.liepin.com/job/1927470809.shtml   \n",
       "19  https://www.liepin.com/job/1925146971.shtml   \n",
       "20  https://www.liepin.com/job/1919826941.shtml   \n",
       "21  https://www.liepin.com/job/1927546457.shtml   \n",
       "22  https://www.liepin.com/job/1927492479.shtml   \n",
       "23  https://www.liepin.com/job/1927492123.shtml   \n",
       "24  https://www.liepin.com/job/1927460427.shtml   \n",
       "25  https://www.liepin.com/job/1927470925.shtml   \n",
       "26  https://www.liepin.com/job/1927470269.shtml   \n",
       "27  https://www.liepin.com/job/1927469381.shtml   \n",
       "28  https://www.liepin.com/job/1927449223.shtml   \n",
       "29  https://www.liepin.com/job/1927471547.shtml   \n",
       "30  https://www.liepin.com/job/1927439789.shtml   \n",
       "31  https://www.liepin.com/job/1927423875.shtml   \n",
       "32  https://www.liepin.com/job/1926698165.shtml   \n",
       "33  https://www.liepin.com/job/1926694451.shtml   \n",
       "34  https://www.liepin.com/job/1923874779.shtml   \n",
       "35  https://www.liepin.com/job/1927409715.shtml   \n",
       "36  https://www.liepin.com/job/1927390671.shtml   \n",
       "37  https://www.liepin.com/job/1927390669.shtml   \n",
       "38  https://www.liepin.com/job/1927319263.shtml   \n",
       "39  https://www.liepin.com/job/1926937565.shtml   \n",
       "\n",
       "                                      公司URL  热门公司类型  \n",
       "0    https://www.liepin.com/company/729252/  中国500强  \n",
       "1   https://www.liepin.com/company/5964833/  中国500强  \n",
       "2   https://www.liepin.com/company/1530833/  中国500强  \n",
       "3   https://www.liepin.com/company/8381953/  中国500强  \n",
       "4   https://www.liepin.com/company/1072424/  中国500强  \n",
       "5   https://www.liepin.com/company/9739005/  中国500强  \n",
       "6   https://www.liepin.com/company/2245242/  中国500强  \n",
       "7   https://www.liepin.com/company/6990643/  中国500强  \n",
       "8   https://www.liepin.com/company/6990643/  中国500强  \n",
       "9   https://www.liepin.com/company/5964833/  中国500强  \n",
       "10  https://www.liepin.com/company/5964833/  中国500强  \n",
       "11  https://www.liepin.com/company/5964833/  中国500强  \n",
       "12  https://www.liepin.com/company/5964833/  中国500强  \n",
       "13   https://www.liepin.com/company/884492/  中国500强  \n",
       "14   https://www.liepin.com/company/884492/  中国500强  \n",
       "15   https://www.liepin.com/company/884492/  中国500强  \n",
       "16  https://www.liepin.com/company/1072424/  中国500强  \n",
       "17  https://www.liepin.com/company/4580900/  中国500强  \n",
       "18  https://www.liepin.com/company/1072424/  中国500强  \n",
       "19  https://www.liepin.com/company/1072424/  中国500强  \n",
       "20  https://www.liepin.com/company/1072424/  中国500强  \n",
       "21  https://www.liepin.com/company/1072424/  中国500强  \n",
       "22  https://www.liepin.com/company/1072424/  中国500强  \n",
       "23  https://www.liepin.com/company/1072424/  中国500强  \n",
       "24  https://www.liepin.com/company/1072424/  中国500强  \n",
       "25  https://www.liepin.com/company/5964833/  中国500强  \n",
       "26   https://www.liepin.com/company/884492/  中国500强  \n",
       "27   https://www.liepin.com/company/884492/  中国500强  \n",
       "28  https://www.liepin.com/company/5964833/  中国500强  \n",
       "29  https://www.liepin.com/company/1072424/  中国500强  \n",
       "..                                      ...     ...  \n",
       "10  https://www.liepin.com/company/8381953/    上市公司  \n",
       "11  https://www.liepin.com/company/9091167/    上市公司  \n",
       "12  https://www.liepin.com/company/7875551/    上市公司  \n",
       "13  https://www.liepin.com/company/2485876/    上市公司  \n",
       "14  https://www.liepin.com/company/8597281/    上市公司  \n",
       "15  https://www.liepin.com/company/7912451/    上市公司  \n",
       "16  https://www.liepin.com/company/1566181/    上市公司  \n",
       "17   https://www.liepin.com/company/719708/    上市公司  \n",
       "18  https://www.liepin.com/company/7327543/    上市公司  \n",
       "19  https://www.liepin.com/company/8904607/    上市公司  \n",
       "20  https://www.liepin.com/company/2485876/    上市公司  \n",
       "21  https://www.liepin.com/company/2036768/    上市公司  \n",
       "22  https://www.liepin.com/company/8712008/    上市公司  \n",
       "23  https://www.liepin.com/company/1072424/    上市公司  \n",
       "24  https://www.liepin.com/company/2485876/    上市公司  \n",
       "25  https://www.liepin.com/company/8597281/    上市公司  \n",
       "26  https://www.liepin.com/company/8597281/    上市公司  \n",
       "27  https://www.liepin.com/company/8597281/    上市公司  \n",
       "28  https://www.liepin.com/company/6612666/    上市公司  \n",
       "29  https://www.liepin.com/company/7873694/    上市公司  \n",
       "30   https://www.liepin.com/company/442197/    上市公司  \n",
       "31  https://www.liepin.com/company/5865181/    上市公司  \n",
       "32  https://www.liepin.com/company/2485876/    上市公司  \n",
       "33  https://www.liepin.com/company/2485876/    上市公司  \n",
       "34  https://www.liepin.com/company/8538316/    上市公司  \n",
       "35  https://www.liepin.com/company/2245242/    上市公司  \n",
       "36  https://www.liepin.com/company/9610439/    上市公司  \n",
       "37  https://www.liepin.com/company/9610439/    上市公司  \n",
       "38  https://www.liepin.com/company/7875551/    上市公司  \n",
       "39  https://www.liepin.com/company/6990643/    上市公司  \n",
       "\n",
       "[240 rows x 10 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# C-3   多个页面\n",
    "url = \"https://www.liepin.com/zhaopin/\"\n",
    "\n",
    "list_df = list()\n",
    "for k,v in 参数_compTag_用户体验.items():\n",
    "    payload = v\n",
    "    df = requests_liepin( url, params = payload)\n",
    "    df = df.assign (热门公司类型 = k)    \n",
    "    list_df.append(df)\n",
    "\n",
    "df_all = pd.concat(list_df)\n",
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "edu         6\n",
      "经验         10\n",
      "薪水         72\n",
      "时间         17\n",
      "职称        177\n",
      "公司地点       65\n",
      "公司名称       74\n",
      "链结        193\n",
      "公司URL      74\n",
      "热门公司类型      6\n",
      "dtype: int64\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司名称</th>\n",
       "      <th>edu</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>中联重科</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">阿里巴巴</th>\n",
       "      <th>学历不限</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>科大讯飞</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>网易集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新东方教育科技集团有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baidu</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>旷视科技</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>首约科技(北京)有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中联重科</th>\n",
       "      <th>博士</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>达而观信息科技(上海)有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京金堤科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>科大讯飞</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>奥飞</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>明略科技集团</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51信用卡管家</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小米</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国金茂控股集团有限公司</th>\n",
       "      <th>硕士及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">SenseTime（商汤集团）</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baidu</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>猎聘</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>沪江</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">新东方教育科技集团有限公司</th>\n",
       "      <th>硕士及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海尔智家</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>纷享销客</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>理想汽车</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国南玻集团股份有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>keenon</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVTE</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京深醒科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华录百纳影视</th>\n",
       "      <th>学历不限</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京金堤科技有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>柳工机械</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>微贷</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>数梦工场</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>山西证券</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小视科技</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58同城</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>旷视科技</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>富银融资租赁</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>易点租</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">杭州网银互联科技股份有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>欧普照明</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广日股份</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天士力集团网</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>涂鸦智能</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳前海达闼科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳市优必选科技股份有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳追一科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>爱康国宾</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大禹节水</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>畅联股份</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华钰矿业</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>神州优车集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新城控股集团住宅开发事业部</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       职称\n",
       "公司名称            edu      \n",
       "中联重科            本科及以上  24\n",
       "阿里巴巴            学历不限   13\n",
       "                本科及以上  11\n",
       "科大讯飞            本科及以上   9\n",
       "网易集团            本科及以上   8\n",
       "新东方教育科技集团有限公司   统招本科    6\n",
       "华为              统招本科    6\n",
       "Baidu           统招本科    6\n",
       "旷视科技            本科及以上   6\n",
       "首约科技(北京)有限公司    大专及以上   5\n",
       "中联重科            博士      5\n",
       "华为              本科及以上   4\n",
       "达而观信息科技(上海)有限公司 本科及以上   4\n",
       "北京金堤科技有限公司      统招本科    4\n",
       "科大讯飞            统招本科    4\n",
       "奥飞              大专及以上   3\n",
       "明略科技集团          统招本科    3\n",
       "51信用卡管家         本科及以上   3\n",
       "小米              本科及以上   3\n",
       "中国金茂控股集团有限公司    硕士及以上   3\n",
       "SenseTime（商汤集团） 统招本科    3\n",
       "                本科及以上   3\n",
       "Baidu           本科及以上   3\n",
       "猎聘              大专及以上   2\n",
       "沪江              大专及以上   2\n",
       "新东方教育科技集团有限公司   硕士及以上   2\n",
       "                本科及以上   2\n",
       "海尔智家            统招本科    2\n",
       "纷享销客            统招本科    2\n",
       "理想汽车            大专及以上   2\n",
       "...                    ..\n",
       "中国南玻集团股份有限公司    本科及以上   1\n",
       "keenon          大专及以上   1\n",
       "CVTE            大专及以上   1\n",
       "北京深醒科技有限公司      统招本科    1\n",
       "华录百纳影视          学历不限    1\n",
       "北京金堤科技有限公司      本科及以上   1\n",
       "柳工机械            本科及以上   1\n",
       "微贷              统招本科    1\n",
       "数梦工场            大专及以上   1\n",
       "山西证券            统招本科    1\n",
       "小视科技            大专及以上   1\n",
       "58同城            统招本科    1\n",
       "旷视科技            大专及以上   1\n",
       "富银融资租赁          统招本科    1\n",
       "易点租             大专及以上   1\n",
       "杭州网银互联科技股份有限公司  大专及以上   1\n",
       "                本科及以上   1\n",
       "欧普照明            大专及以上   1\n",
       "广日股份            本科及以上   1\n",
       "天士力集团网          统招本科    1\n",
       "涂鸦智能            本科及以上   1\n",
       "深圳前海达闼科技有限公司    统招本科    1\n",
       "深圳市优必选科技股份有限公司  统招本科    1\n",
       "深圳追一科技有限公司      统招本科    1\n",
       "爱康国宾            大专及以上   1\n",
       "大禹节水            统招本科    1\n",
       "畅联股份            本科及以上   1\n",
       "华钰矿业            本科及以上   1\n",
       "神州优车集团          本科及以上   1\n",
       "新城控股集团住宅开发事业部   本科及以上   1\n",
       "\n",
       "[97 rows x 1 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print (df_all.nunique())\n",
    "df_all[['edu']].drop_duplicates()\n",
    "\n",
    "df_all.groupby(['公司名称','edu']).agg({\"职称\":\"count\"}).sort_values(by='职称', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>职称</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>公司名称</th>\n",
       "      <th>edu</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>中联重科</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">阿里巴巴</th>\n",
       "      <th>学历不限</th>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>科大讯飞</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>网易集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新东方教育科技集团有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baidu</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>旷视科技</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>首约科技(北京)有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中联重科</th>\n",
       "      <th>博士</th>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华为</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>达而观信息科技(上海)有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京金堤科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>科大讯飞</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>奥飞</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>明略科技集团</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51信用卡管家</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小米</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国金茂控股集团有限公司</th>\n",
       "      <th>硕士及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">SenseTime（商汤集团）</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Baidu</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>猎聘</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>沪江</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">新东方教育科技集团有限公司</th>\n",
       "      <th>硕士及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>海尔智家</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>纷享销客</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>理想汽车</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>中国南玻集团股份有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>keenon</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVTE</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京深醒科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华录百纳影视</th>\n",
       "      <th>学历不限</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>北京金堤科技有限公司</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>柳工机械</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>微贷</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>数梦工场</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>山西证券</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小视科技</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58同城</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>旷视科技</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>富银融资租赁</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>易点租</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">杭州网银互联科技股份有限公司</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>欧普照明</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>广日股份</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>天士力集团网</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>涂鸦智能</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳前海达闼科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳市优必选科技股份有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>深圳追一科技有限公司</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>爱康国宾</th>\n",
       "      <th>大专及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大禹节水</th>\n",
       "      <th>统招本科</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>畅联股份</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华钰矿业</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>神州优车集团</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>新城控股集团住宅开发事业部</th>\n",
       "      <th>本科及以上</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       职称\n",
       "公司名称            edu      \n",
       "中联重科            本科及以上  24\n",
       "阿里巴巴            学历不限   13\n",
       "                本科及以上  11\n",
       "科大讯飞            本科及以上   9\n",
       "网易集团            本科及以上   8\n",
       "新东方教育科技集团有限公司   统招本科    6\n",
       "华为              统招本科    6\n",
       "Baidu           统招本科    6\n",
       "旷视科技            本科及以上   6\n",
       "首约科技(北京)有限公司    大专及以上   5\n",
       "中联重科            博士      5\n",
       "华为              本科及以上   4\n",
       "达而观信息科技(上海)有限公司 本科及以上   4\n",
       "北京金堤科技有限公司      统招本科    4\n",
       "科大讯飞            统招本科    4\n",
       "奥飞              大专及以上   3\n",
       "明略科技集团          统招本科    3\n",
       "51信用卡管家         本科及以上   3\n",
       "小米              本科及以上   3\n",
       "中国金茂控股集团有限公司    硕士及以上   3\n",
       "SenseTime（商汤集团） 统招本科    3\n",
       "                本科及以上   3\n",
       "Baidu           本科及以上   3\n",
       "猎聘              大专及以上   2\n",
       "沪江              大专及以上   2\n",
       "新东方教育科技集团有限公司   硕士及以上   2\n",
       "                本科及以上   2\n",
       "海尔智家            统招本科    2\n",
       "纷享销客            统招本科    2\n",
       "理想汽车            大专及以上   2\n",
       "...                    ..\n",
       "中国南玻集团股份有限公司    本科及以上   1\n",
       "keenon          大专及以上   1\n",
       "CVTE            大专及以上   1\n",
       "北京深醒科技有限公司      统招本科    1\n",
       "华录百纳影视          学历不限    1\n",
       "北京金堤科技有限公司      本科及以上   1\n",
       "柳工机械            本科及以上   1\n",
       "微贷              统招本科    1\n",
       "数梦工场            大专及以上   1\n",
       "山西证券            统招本科    1\n",
       "小视科技            大专及以上   1\n",
       "58同城            统招本科    1\n",
       "旷视科技            大专及以上   1\n",
       "富银融资租赁          统招本科    1\n",
       "易点租             大专及以上   1\n",
       "杭州网银互联科技股份有限公司  大专及以上   1\n",
       "                本科及以上   1\n",
       "欧普照明            大专及以上   1\n",
       "广日股份            本科及以上   1\n",
       "天士力集团网          统招本科    1\n",
       "涂鸦智能            本科及以上   1\n",
       "深圳前海达闼科技有限公司    统招本科    1\n",
       "深圳市优必选科技股份有限公司  统招本科    1\n",
       "深圳追一科技有限公司      统招本科    1\n",
       "爱康国宾            大专及以上   1\n",
       "大禹节水            统招本科    1\n",
       "畅联股份            本科及以上   1\n",
       "华钰矿业            本科及以上   1\n",
       "神州优车集团          本科及以上   1\n",
       "新城控股集团住宅开发事业部   本科及以上   1\n",
       "\n",
       "[97 rows x 1 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all.groupby(['公司名称','edu']).agg({\"职称\":\"count\"}).sort_values(by='职称', ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 列表推算"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "￥3999.00\n",
      "小米\n",
      "10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+128GB 钛银黑 拍照智能游戏手机 限时白条24期免息，现货速发【小米10旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥4299.00\n",
      "小米\n",
      "10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+256GB 钛银黑 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥1699.00\n",
      "Redmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 6GB+128GB 深海微光 游戏智能手机\n",
      "小米\n",
      "红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥1099.00\n",
      "Redmi Note8 4800万全场景四摄 4000mAh长续航 高通骁龙665 18W快充 小金刚品质保证 6GB+64GB 曜石黑 游戏智能手机\n",
      "小米\n",
      "红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥4999.00\n",
      "小米\n",
      "10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 8GB+256GB 珍珠白 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "北京预订\n",
      "￥749.00\n",
      "Redmi 8A 5000mAh大电量 大字体大音量大内存 骁龙八核处理器 AI人脸解锁 莱茵护眼全面屏 4GB+64GB 耀夜黑 游戏智能老人手机\n",
      "小米\n",
      "红米 【品质好物，增耳机】5000mAh大电量,支持18W快充,Type-C充电接口！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥3999.00\n",
      "小米\n",
      "10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声8GB +128GB 冰海蓝 拍照智能游戏手机 限时白条24期免息，现货速发【小米10旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥1299.00\n",
      "Redmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+64GB 贝母白 游戏智能手机\n",
      "小米\n",
      "红米 【品质好物，赠耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥5999.00\n",
      "小米\n",
      "10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 12GB+512GB 珍珠白 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥4299.00\n",
      "小米\n",
      "10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+256GB 冰海蓝 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥1699.00\n",
      "Redmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 6GB+128GB 紫玉幻境 游戏智能手机\n",
      "小米\n",
      "红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥4999.00\n",
      "小米\n",
      "10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 8GB+256GB 星空蓝 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "北京预订\n",
      "￥3999.00\n",
      "小米\n",
      "10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+128GB 蜜桃金 拍照智能游戏手机 限时白条24期免息，现货速发【小米10旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "北京预订\n",
      "￥899.00\n",
      "Redmi Note8 4800万全场景四摄 4000mAh长续航 高通骁龙665 18W快充 小金刚品质保证 4GB+64GB 皓月白 游戏智能手机\n",
      "小米\n",
      "红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "北京预订\n",
      "￥4699.00\n",
      "小米\n",
      "10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 12GB+256GB 钛银黑 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥1099.00\n",
      "Redmi Note8 4800万全场景四摄 4000mAh长续航 高通骁龙665 18W快充 小金刚品质保证 6GB+64GB 皓月白 游戏智能手机\n",
      "小米\n",
      "红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥1399.00\n",
      "Redmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+128GB 电光灰 游戏智能手机\n",
      "小米\n",
      "红米 【品质好物，增耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥1299.00\n",
      "Redmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+64GB 冰翡翠 游戏智能手机\n",
      "小米\n",
      "红米 【品质好物，赠耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥1899.00\n",
      "Redmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 8GB+128GB 深海微光 游戏智能手机\n",
      "小米\n",
      "红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥3399.00\n",
      "Redmi K30 Pro 5G先锋 骁龙865旗舰处理器 弹出式超光感全面屏 索尼6400万高清四摄 4700mAh长续航 33W闪充 8GB+128GB 天际蓝 游戏智能手机\n",
      "小米\n",
      "红米 【24期免息，火热购买中】8K视频拍摄，骁龙865旗舰处理器【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 新品 赠\n",
      "对比 关注 加入购物车\n",
      "￥5999.00\n",
      "小米\n",
      "10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 12GB+512GB 星空蓝 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "北京预订\n",
      "￥2999.00\n",
      "Redmi K30 Pro 5G先锋 骁龙865旗舰处理器 弹出式超光感全面屏 索尼6400万高清四摄 4700mAh长续航 33W闪充 6GB+128GB 天际蓝 游戏智能手机\n",
      "小米\n",
      "红米 【24期免息，火热购买中】8K视频拍摄，骁龙865旗舰处理器【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 新品 赠\n",
      "对比 关注 加入购物车\n",
      "￥1099.00\n",
      "Redmi Note8 4800万全场景四摄 4000mAh 高通骁龙665 18W快充 6GB+64GB 梦幻蓝 游戏手机\n",
      "小米\n",
      "红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥1899.00\n",
      "Redmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 8GB+128GB 紫玉幻境 游戏智能手机\n",
      "小米\n",
      "红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥3199.00节能补贴\n",
      "小米\n",
      "电视4A 70英寸 4K超高清 HDR 二级能效 2GB+16GB 内置小爱 AI人工智能网络液晶平板教育电视L70M5-4A 70英寸是什么体验？高性能巨幕，双眼沉浸，身临其境！大屏新世界，更多选择》点击进入《\n",
      "选购指数2.1\n",
      "小米京东自营旗舰店\n",
      "自营\n",
      "对比 关注 加入购物车\n",
      "￥4299.00\n",
      "RedmiBook 14 增强版 全金属超轻薄(第十代英特尔酷睿i5-10210U 8G 512G SSD MX250 2G独显 支持手环疾速解锁 Office)游戏 银 笔记本\n",
      "小米\n",
      "红米 【十代处理器新品】【年度旗舰机】全金属机身、增强版酷睿I5处理器、MX250高性能显卡、全高清窄边框、支持手环疾速解锁更多爆款\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营\n",
      "对比 关注 加入购物车\n",
      "￥3399.00\n",
      "Redmi K30 Pro 5G先锋 骁龙865旗舰处理器 弹出式超光感全面屏 索尼6400万高清四摄 4700mAh长续航 33W闪充 8GB+128GB 太空灰 游戏智能手机\n",
      "小米\n",
      "红米 【24期免息，火热购买中】8K视频拍摄，骁龙865旗舰处理器【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 新品 赠\n",
      "对比 关注 加入购物车\n",
      "￥1299.00\n",
      "Redmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+64GB 电光灰 游戏智能手机\n",
      "小米\n",
      "红米 【品质好物，赠耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\n",
      "小米京东自营旗舰店\n",
      "自营 放心购 赠\n",
      "对比 关注 加入购物车\n",
      "￥2399.00\n",
      "Redmi K30 王一博同款 5G双模 120Hz流速屏 骁龙765G 30W快充 8GB+128GB 深海微光 游戏智能手机\n",
      "小米\n",
      "红米 【六期免息，新品热销】RedmiK305G版，120Hz流速屏【K30pro火热购买中】\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n",
      "￥4299.00\n",
      "小米\n",
      "10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+256GB 蜜桃金 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\n",
      "二手有售\n",
      "小米京东自营旗舰店\n",
      "自营 赠\n",
      "对比 关注 加入购物车\n"
     ]
    }
   ],
   "source": [
    "# Z-1 別人代碼\n",
    "from requests_html import HTMLSession\n",
    "session = HTMLSession()\n",
    "\n",
    "url = 'https://search.jd.com/Search?keyword=%E5%B0%8F%E7%B1%B3&enc=utf-8&wq=%E5%B0%8F%E7%B1%B3&pvid=c1163073c31a4778b530625888dc4834'\n",
    "r = session.get(url)\n",
    "link_list = r.html.find('.gl-item')\n",
    "for i in link_list:\n",
    "    print(i.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['￥3999.00\\n小米\\n10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+128GB 钛银黑 拍照智能游戏手机 限时白条24期免息，现货速发【小米10旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥4299.00\\n小米\\n10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+256GB 钛银黑 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥1699.00\\nRedmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 6GB+128GB 深海微光 游戏智能手机\\n小米\\n红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥1099.00\\nRedmi Note8 4800万全场景四摄 4000mAh长续航 高通骁龙665 18W快充 小金刚品质保证 6GB+64GB 曜石黑 游戏智能手机\\n小米\\n红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥4999.00\\n小米\\n10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 8GB+256GB 珍珠白 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车\\n北京预订',\n",
       " '￥749.00\\nRedmi 8A 5000mAh大电量 大字体大音量大内存 骁龙八核处理器 AI人脸解锁 莱茵护眼全面屏 4GB+64GB 耀夜黑 游戏智能老人手机\\n小米\\n红米 【品质好物，增耳机】5000mAh大电量,支持18W快充,Type-C充电接口！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥3999.00\\n小米\\n10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声8GB +128GB 冰海蓝 拍照智能游戏手机 限时白条24期免息，现货速发【小米10旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥1299.00\\nRedmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+64GB 贝母白 游戏智能手机\\n小米\\n红米 【品质好物，赠耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥5999.00\\n小米\\n10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 12GB+512GB 珍珠白 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥4299.00\\n小米\\n10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+256GB 冰海蓝 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥1699.00\\nRedmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 6GB+128GB 紫玉幻境 游戏智能手机\\n小米\\n红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥4999.00\\n小米\\n10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 8GB+256GB 星空蓝 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车\\n北京预订',\n",
       " '￥3999.00\\n小米\\n10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+128GB 蜜桃金 拍照智能游戏手机 限时白条24期免息，现货速发【小米10旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车\\n北京预订',\n",
       " '￥899.00\\nRedmi Note8 4800万全场景四摄 4000mAh长续航 高通骁龙665 18W快充 小金刚品质保证 4GB+64GB 皓月白 游戏智能手机\\n小米\\n红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车\\n北京预订',\n",
       " '￥4699.00\\n小米\\n10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 12GB+256GB 钛银黑 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥1099.00\\nRedmi Note8 4800万全场景四摄 4000mAh长续航 高通骁龙665 18W快充 小金刚品质保证 6GB+64GB 皓月白 游戏智能手机\\n小米\\n红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥1399.00\\nRedmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+128GB 电光灰 游戏智能手机\\n小米\\n红米 【品质好物，增耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥1299.00\\nRedmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+64GB 冰翡翠 游戏智能手机\\n小米\\n红米 【品质好物，赠耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥1899.00\\nRedmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 8GB+128GB 深海微光 游戏智能手机\\n小米\\n红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥3399.00\\nRedmi K30 Pro 5G先锋 骁龙865旗舰处理器 弹出式超光感全面屏 索尼6400万高清四摄 4700mAh长续航 33W闪充 8GB+128GB 天际蓝 游戏智能手机\\n小米\\n红米 【24期免息，火热购买中】8K视频拍摄，骁龙865旗舰处理器【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 新品 赠\\n对比 关注 加入购物车',\n",
       " '￥5999.00\\n小米\\n10 Pro 双模5G 骁龙865 1亿像素8K电影相机 50倍变焦 50W快充 12GB+512GB 星空蓝 拍照智能游戏手机 享白条6期免息，现货速发【小米10pro旗舰新品抢购中，不容错过】领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车\\n北京预订',\n",
       " '￥2999.00\\nRedmi K30 Pro 5G先锋 骁龙865旗舰处理器 弹出式超光感全面屏 索尼6400万高清四摄 4700mAh长续航 33W闪充 6GB+128GB 天际蓝 游戏智能手机\\n小米\\n红米 【24期免息，火热购买中】8K视频拍摄，骁龙865旗舰处理器【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 新品 赠\\n对比 关注 加入购物车',\n",
       " '￥1099.00\\nRedmi Note8 4800万全场景四摄 4000mAh 高通骁龙665 18W快充 6GB+64GB 梦幻蓝 游戏手机\\n小米\\n红米 【品质好物，增耳机】小金刚品质保证，骁龙665处理器，标配18W充电器！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥1899.00\\nRedmi K30 王一博同款 120Hz流速屏 前置挖孔双摄 8GB+128GB 紫玉幻境 游戏智能手机\\n小米\\n红米 【六期免息，新品热销】120Hz流速屏，王一博同款火爆开售【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥3199.00节能补贴\\n小米\\n电视4A 70英寸 4K超高清 HDR 二级能效 2GB+16GB 内置小爱 AI人工智能网络液晶平板教育电视L70M5-4A 70英寸是什么体验？高性能巨幕，双眼沉浸，身临其境！大屏新世界，更多选择》点击进入《\\n选购指数2.1\\n小米京东自营旗舰店\\n自营\\n对比 关注 加入购物车',\n",
       " '￥4299.00\\nRedmiBook 14 增强版 全金属超轻薄(第十代英特尔酷睿i5-10210U 8G 512G SSD MX250 2G独显 支持手环疾速解锁 Office)游戏 银 笔记本\\n小米\\n红米 【十代处理器新品】【年度旗舰机】全金属机身、增强版酷睿I5处理器、MX250高性能显卡、全高清窄边框、支持手环疾速解锁更多爆款\\n二手有售\\n小米京东自营旗舰店\\n自营\\n对比 关注 加入购物车',\n",
       " '￥3399.00\\nRedmi K30 Pro 5G先锋 骁龙865旗舰处理器 弹出式超光感全面屏 索尼6400万高清四摄 4700mAh长续航 33W闪充 8GB+128GB 太空灰 游戏智能手机\\n小米\\n红米 【24期免息，火热购买中】8K视频拍摄，骁龙865旗舰处理器【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 新品 赠\\n对比 关注 加入购物车',\n",
       " '￥1299.00\\nRedmi Note8Pro 6400万全场景四摄 液冷游戏芯 4500mAh长续航 NFC 18W快充 红外遥控 6GB+64GB 电光灰 游戏智能手机\\n小米\\n红米 【品质好物，赠耳机】小金刚品质保证，6400万超广角四摄，3D四曲面玻璃机身！【K30pro火热购买中】\\n小米京东自营旗舰店\\n自营 放心购 赠\\n对比 关注 加入购物车',\n",
       " '￥2399.00\\nRedmi K30 王一博同款 5G双模 120Hz流速屏 骁龙765G 30W快充\\xa08GB+128GB 深海微光 游戏智能手机\\n小米\\n红米 【六期免息，新品热销】RedmiK305G版，120Hz流速屏【K30pro火热购买中】\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车',\n",
       " '￥4299.00\\n小米\\n10 双模5G 骁龙865 1亿像素8K电影相机 对称式立体声 8GB+256GB 蜜桃金 拍照智能游戏手机 限时白条24期免息，下单限时赠价值99元耳机，数量有限，赠完即止，现货速发领赠品送10万京豆/2400G流量\\n二手有售\\n小米京东自营旗舰店\\n自营 赠\\n对比 关注 加入购物车']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Z-1 別人代碼 列表推導\n",
    "'''\n",
    "link_list = r.html.find('.gl-item')\n",
    "列表暫存 = list()\n",
    "for i in link_list:\n",
    "    列表暫存.append(i.text)\n",
    "    #print(i.text)\n",
    "'''\n",
    "[i.text for i in link_list]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
